package cc.mrbird.submission.dao;

import cc.mrbird.submission.domain.PullDown;
import cc.mrbird.submission.domain.SubmissionEntry;
import org.springframework.ui.Model;

import java.util.List;

public interface SubmissionMapper{

    void saveSubmissionEntry(SubmissionEntry submissionEntry);

    List<SubmissionEntry> getSubmissionEntryList(SubmissionEntry submissionEntry);

    void updateSubmission (SubmissionEntry submissionEntry);

    List<PullDown> FindPullDown(PullDown pullDown);

    void addPullDown(PullDown pullDown );

    void cancelSubmission(SubmissionEntry submissionEntry );

    void importSubmissionEntry(SubmissionEntry submissionEntry);

    PullDown savePullDown(PullDown pullDown );

    List<SubmissionEntry> getSubmissionEntryExportExcel(SubmissionEntry submissionEntry);

    //查询最新的id
    String findId();

    /**
     * 每日报文发送
     */
    int sum1(String startTime11,String endTime11);
    int sum2(String startTime11,String endTime11);
    int sum3(String startTime11,String endTime11);
    int sum4(String startTime11,String endTime11);
    int sum5(String startTime11,String endTime11);
    int sum6(String startTime11,String endTime11);
    int sum7(String startTime11,String endTime11);
    int sum8(String startTime11,String endTime11);
    int sum9(String startTime12,String endTime12);
    int sum10(String startTime12,String endTime12);
    int sum11(String startTime12,String endTime12);
    int sum12(String startTime12,String endTime12);
    int sum13(String endTime11);
    int sum14(String endTime11);
    int sum15(String endTime11);
    int sum16(String endTime11);
    int sum17(String startTime12,String endTime12,String startTime11,String endTime11);
    int sum18(String startTime12,String endTime12,String startTime11,String endTime11);

    SubmissionEntry getSubmissionEntry(SubmissionEntry submissionEntry);

    //三亚统计优先处理数量
    String sumFirst();

    //陵水统计优先处理数量
    String sumFirst1();
}

